USE [vudu]
GO
/****** Object:  StoredProcedure [dbo].[SELestudianteCed]   
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
procedimiento que busca un estudiante en especifico*/
CREATE PROCEDURE [dbo].[SELestudianteCed]
@ced int
AS
BEGIN
	SET NOCOUNT ON;
	
	SELECT u.id_estudiante, u.noExpediente, u.cedula, u.nombre, u.apellido, u.fechaNac, u.sexo, u.telefono, u.correo
	FROM ESTUDIANTE u
	WHERE u.cedula = @ced;
END;

--SET ANSI_NULLS ON